<?php
/*****************************************************************************************
 * X2CRM Open Source Edition is a customer relationship management program developed by
 * X2Engine, Inc. Copyright (C) 2011-2013 X2Engine Inc.
 * 
 * This program is free software; you can redistribute it and/or modify it under
 * the terms of the GNU Affero General Public License version 3 as published by the
 * Free Software Foundation with the addition of the following permission added
 * to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
 * IN WHICH THE COPYRIGHT IS OWNED BY X2ENGINE, X2ENGINE DISCLAIMS THE WARRANTY
 * OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
 * 
 * This program is distributed in the hope that it will be useful, but WITHOUT
 * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
 * FOR A PARTICULAR PURPOSE.  See the GNU Affero General Public License for more
 * details.
 * 
 * You should have received a copy of the GNU Affero General Public License along with
 * this program; if not, see http://www.gnu.org/licenses or write to the Free
 * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
 * 02110-1301 USA.
 * 
 * You can contact X2Engine, Inc. P.O. Box 66752, Scotts Valley,
 * California 95067, USA. or at email address contact@x2engine.com.
 * 
 * The interactive user interfaces in modified source and object code versions
 * of this program must display Appropriate Legal Notices, as required under
 * Section 5 of the GNU Affero General Public License version 3.
 * 
 * In accordance with Section 7(b) of the GNU Affero General Public License version 3,
 * these Appropriate Legal Notices must retain the display of the "Powered by
 * X2Engine" logo. If the display of the logo is not reasonably feasible for
 * technical reasons, the Appropriate Legal Notices must display the words
 * "Powered by X2Engine".
 *****************************************************************************************/

/**
 * This is the model class for table "x2_widgets".
 *
 * @package X2CRM.modules.dashboard.models
 * @property integer $id(auto-incremented)
 * @property string $name
 * @property integer $showPROFILE
 * @property integer $adminALLOWS
 * @property integer $showDASH
 * @property integer $userID
 * @property integer $position
 */
class Dashboard extends CActiveRecord{
	/**
	 * Returns the static model of the specified AR class.
	 * @return Roles the static model class
	 */
	public static function model($className=__CLASS__)
	{
		return parent::model($className);
	}

	/**
	 * @return string the associated database table name
	 */
	public function tableName()
	{
		return 'x2_widgets';
	}

	/**
	 * @return array validation rules for model attributes.
	 */
	public function rules()
	{
		// NOTE: you should only define rules for those attributes that
		// will receive user inputs.
		return array(
			array('name,position', 'required'),
			array('name', 'length', 'max'=>250),
			array('id', 'safe'),
			// The following rule is used by search().
			// Please remove those attributes that should not be searched.
			array('name,showPROFILE,adminALLOWS,showDASH,userID,position', 'safe', 'on'=>'search'),
		);
	}

	/**
	 * @return array relational rules.
	 */
	public function relations()
	{
		// NOTE: you may need to adjust the relation name and the related
		// class name for the relations automatically generated below.
		return array(
		);
	}

	/**
	 * @return array customized attribute labels (name=>label)
	 */
	public function attributeLabels()
    {
        return array(
            "showProfile"=>"Shown in Profile",
            "adminALLOWS"=>"Admin Allows Display",
            "userID"=>"User ID",
            "posPROF"=>"Position in Profile",
            "posDASH"=>"Position in Dashboard",
            "dispNAME"=>"Display Name",
            "userALLOWS"=>"User Allows Display"
        );
    }
	/**
	 * Retrieves a list of models based on the current search/filter conditions.
	 * @return CActiveDataProvider the data provider that can return the models based on the search/filter conditions.
	 */
	public function search($id){
		// Warning: Please modify the following code to remove attributes that
        // should not be searched.
        $uid = Yii::app()->user->getId();
        if ($id == 'dash'){
            if ($uid != 1){
                $sql = "SELECT * FROM x2_widgets WHERE adminALLOWS = 1 AND userID = $uid AND userALLOWS = 1 AND needUSER = 0";
                $command = Yii::app()->db->createCommand($sql);
                $rows = $command->queryAll();
            }else {
                $query = "SELECT * FROM x2_widgets WHERE userID = $uid AND userALLOWS = 1 AND needUSER = 0";
                $command = Yii::app()->db->createCommand($query);
                $rows = $command->queryAll();
            }
            return $rows;
        }else{ 
           $criteria = new CDbCriteria;
           if ($uid != 1) $criteria->compare('adminALLOWS',1,true);
           $criteria->compare('userID',$uid,true);
           $criteria->compare('showPROFILE',1,true);
           if ($id != "prof") $criteria->compare('id',$id,true);
           $data =  new CActiveDataProvider(get_class($this),array(
               'sort'=>array('defaultOrder'=>'posPROF ASC'),
               'pagination'=>array(
                   'pageSize'=>12,
               ),
               'criteria'=>$criteria
           ));
           return $data;
        }
    }

}
